# -*- coding: utf-8 -*-
# Description:
# Created: dingwenjing 2022/11/29
from app.main.dao.sqlalchemy_dao import SQLAlchemyDao


# 数据库访问层，新加方法调用SQLAlchemyDao中的方法即可
class HelloDao():
    @staticmethod
    def select():
        """
        查询
        :return:
        """

        sql = """
        select S104_0000.TOP_YS_1, S101_0000.PROD_TIME,S101_0000.FINAL_COIL_FLAG,S101_0000.FM_MODE_SET,S101_0000.FUR_LINE_NO,S101_0000.FUR_NO,S101_0000.HOT_CHARGE_FLAG,S101_0000.MAT_NO,S101_0000.PROD_SHIFT_GROUP,S101_0000.PROD_SHIFT_NO from BGZGMOQMTQ.T_ODS_TQMTQZGT1 AS S104_0000 INNER JOIN BGZGMOMMHR.T_ODS_TMMHRZG015 AS S101_0000 ON S101_0000.SLAB_NO=S104_0000.SLAB_NO and  1 = 1  and ( S101_0000.PROD_TIME BETWEEN '20230724000000' AND '20230824100011' )
    """
        data = SQLAlchemyDao.select_all(sql)
        return data
